package com.spongeli.entity;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class SaleThreadExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SaleThreadExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andPidIsNull() {
            addCriterion("PID is null");
            return (Criteria) this;
        }

        public Criteria andPidIsNotNull() {
            addCriterion("PID is not null");
            return (Criteria) this;
        }

        public Criteria andPidEqualTo(Long value) {
            addCriterion("PID =", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotEqualTo(Long value) {
            addCriterion("PID <>", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThan(Long value) {
            addCriterion("PID >", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidGreaterThanOrEqualTo(Long value) {
            addCriterion("PID >=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThan(Long value) {
            addCriterion("PID <", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidLessThanOrEqualTo(Long value) {
            addCriterion("PID <=", value, "pid");
            return (Criteria) this;
        }

        public Criteria andPidIn(List<Long> values) {
            addCriterion("PID in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotIn(List<Long> values) {
            addCriterion("PID not in", values, "pid");
            return (Criteria) this;
        }

        public Criteria andPidBetween(Long value1, Long value2) {
            addCriterion("PID between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andPidNotBetween(Long value1, Long value2) {
            addCriterion("PID not between", value1, value2, "pid");
            return (Criteria) this;
        }

        public Criteria andCustomernameIsNull() {
            addCriterion("CustomerName is null");
            return (Criteria) this;
        }

        public Criteria andCustomernameIsNotNull() {
            addCriterion("CustomerName is not null");
            return (Criteria) this;
        }

        public Criteria andCustomernameEqualTo(String value) {
            addCriterion("CustomerName =", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameNotEqualTo(String value) {
            addCriterion("CustomerName <>", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameGreaterThan(String value) {
            addCriterion("CustomerName >", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameGreaterThanOrEqualTo(String value) {
            addCriterion("CustomerName >=", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameLessThan(String value) {
            addCriterion("CustomerName <", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameLessThanOrEqualTo(String value) {
            addCriterion("CustomerName <=", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameLike(String value) {
            addCriterion("CustomerName like", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameNotLike(String value) {
            addCriterion("CustomerName not like", value, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameIn(List<String> values) {
            addCriterion("CustomerName in", values, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameNotIn(List<String> values) {
            addCriterion("CustomerName not in", values, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameBetween(String value1, String value2) {
            addCriterion("CustomerName between", value1, value2, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomernameNotBetween(String value1, String value2) {
            addCriterion("CustomerName not between", value1, value2, "customername");
            return (Criteria) this;
        }

        public Criteria andCustomertelIsNull() {
            addCriterion("CustomerTel is null");
            return (Criteria) this;
        }

        public Criteria andCustomertelIsNotNull() {
            addCriterion("CustomerTel is not null");
            return (Criteria) this;
        }

        public Criteria andCustomertelEqualTo(String value) {
            addCriterion("CustomerTel =", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelNotEqualTo(String value) {
            addCriterion("CustomerTel <>", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelGreaterThan(String value) {
            addCriterion("CustomerTel >", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelGreaterThanOrEqualTo(String value) {
            addCriterion("CustomerTel >=", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelLessThan(String value) {
            addCriterion("CustomerTel <", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelLessThanOrEqualTo(String value) {
            addCriterion("CustomerTel <=", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelLike(String value) {
            addCriterion("CustomerTel like", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelNotLike(String value) {
            addCriterion("CustomerTel not like", value, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelIn(List<String> values) {
            addCriterion("CustomerTel in", values, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelNotIn(List<String> values) {
            addCriterion("CustomerTel not in", values, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelBetween(String value1, String value2) {
            addCriterion("CustomerTel between", value1, value2, "customertel");
            return (Criteria) this;
        }

        public Criteria andCustomertelNotBetween(String value1, String value2) {
            addCriterion("CustomerTel not between", value1, value2, "customertel");
            return (Criteria) this;
        }

        public Criteria andGenderIsNull() {
            addCriterion("Gender is null");
            return (Criteria) this;
        }

        public Criteria andGenderIsNotNull() {
            addCriterion("Gender is not null");
            return (Criteria) this;
        }

        public Criteria andGenderEqualTo(Byte value) {
            addCriterion("Gender =", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotEqualTo(Byte value) {
            addCriterion("Gender <>", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThan(Byte value) {
            addCriterion("Gender >", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderGreaterThanOrEqualTo(Byte value) {
            addCriterion("Gender >=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThan(Byte value) {
            addCriterion("Gender <", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderLessThanOrEqualTo(Byte value) {
            addCriterion("Gender <=", value, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderIn(List<Byte> values) {
            addCriterion("Gender in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotIn(List<Byte> values) {
            addCriterion("Gender not in", values, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderBetween(Byte value1, Byte value2) {
            addCriterion("Gender between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andGenderNotBetween(Byte value1, Byte value2) {
            addCriterion("Gender not between", value1, value2, "gender");
            return (Criteria) this;
        }

        public Criteria andWechatnumIsNull() {
            addCriterion("WeChatNum is null");
            return (Criteria) this;
        }

        public Criteria andWechatnumIsNotNull() {
            addCriterion("WeChatNum is not null");
            return (Criteria) this;
        }

        public Criteria andWechatnumEqualTo(String value) {
            addCriterion("WeChatNum =", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumNotEqualTo(String value) {
            addCriterion("WeChatNum <>", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumGreaterThan(String value) {
            addCriterion("WeChatNum >", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumGreaterThanOrEqualTo(String value) {
            addCriterion("WeChatNum >=", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumLessThan(String value) {
            addCriterion("WeChatNum <", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumLessThanOrEqualTo(String value) {
            addCriterion("WeChatNum <=", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumLike(String value) {
            addCriterion("WeChatNum like", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumNotLike(String value) {
            addCriterion("WeChatNum not like", value, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumIn(List<String> values) {
            addCriterion("WeChatNum in", values, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumNotIn(List<String> values) {
            addCriterion("WeChatNum not in", values, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumBetween(String value1, String value2) {
            addCriterion("WeChatNum between", value1, value2, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andWechatnumNotBetween(String value1, String value2) {
            addCriterion("WeChatNum not between", value1, value2, "wechatnum");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidIsNull() {
            addCriterion("ThreadSourceID is null");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidIsNotNull() {
            addCriterion("ThreadSourceID is not null");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidEqualTo(Long value) {
            addCriterion("ThreadSourceID =", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidNotEqualTo(Long value) {
            addCriterion("ThreadSourceID <>", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidGreaterThan(Long value) {
            addCriterion("ThreadSourceID >", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidGreaterThanOrEqualTo(Long value) {
            addCriterion("ThreadSourceID >=", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidLessThan(Long value) {
            addCriterion("ThreadSourceID <", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidLessThanOrEqualTo(Long value) {
            addCriterion("ThreadSourceID <=", value, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidIn(List<Long> values) {
            addCriterion("ThreadSourceID in", values, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidNotIn(List<Long> values) {
            addCriterion("ThreadSourceID not in", values, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidBetween(Long value1, Long value2) {
            addCriterion("ThreadSourceID between", value1, value2, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadsourceidNotBetween(Long value1, Long value2) {
            addCriterion("ThreadSourceID not between", value1, value2, "threadsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidIsNull() {
            addCriterion("ThreadParentSourceID is null");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidIsNotNull() {
            addCriterion("ThreadParentSourceID is not null");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidEqualTo(Long value) {
            addCriterion("ThreadParentSourceID =", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidNotEqualTo(Long value) {
            addCriterion("ThreadParentSourceID <>", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidGreaterThan(Long value) {
            addCriterion("ThreadParentSourceID >", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidGreaterThanOrEqualTo(Long value) {
            addCriterion("ThreadParentSourceID >=", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidLessThan(Long value) {
            addCriterion("ThreadParentSourceID <", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidLessThanOrEqualTo(Long value) {
            addCriterion("ThreadParentSourceID <=", value, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidIn(List<Long> values) {
            addCriterion("ThreadParentSourceID in", values, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidNotIn(List<Long> values) {
            addCriterion("ThreadParentSourceID not in", values, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidBetween(Long value1, Long value2) {
            addCriterion("ThreadParentSourceID between", value1, value2, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andThreadparentsourceidNotBetween(Long value1, Long value2) {
            addCriterion("ThreadParentSourceID not between", value1, value2, "threadparentsourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidIsNull() {
            addCriterion("ActivitySourceID is null");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidIsNotNull() {
            addCriterion("ActivitySourceID is not null");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidEqualTo(Long value) {
            addCriterion("ActivitySourceID =", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidNotEqualTo(Long value) {
            addCriterion("ActivitySourceID <>", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidGreaterThan(Long value) {
            addCriterion("ActivitySourceID >", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidGreaterThanOrEqualTo(Long value) {
            addCriterion("ActivitySourceID >=", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidLessThan(Long value) {
            addCriterion("ActivitySourceID <", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidLessThanOrEqualTo(Long value) {
            addCriterion("ActivitySourceID <=", value, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidIn(List<Long> values) {
            addCriterion("ActivitySourceID in", values, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidNotIn(List<Long> values) {
            addCriterion("ActivitySourceID not in", values, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidBetween(Long value1, Long value2) {
            addCriterion("ActivitySourceID between", value1, value2, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andActivitysourceidNotBetween(Long value1, Long value2) {
            addCriterion("ActivitySourceID not between", value1, value2, "activitysourceid");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNull() {
            addCriterion("DataStatus is null");
            return (Criteria) this;
        }

        public Criteria andDatastatusIsNotNull() {
            addCriterion("DataStatus is not null");
            return (Criteria) this;
        }

        public Criteria andDatastatusEqualTo(Byte value) {
            addCriterion("DataStatus =", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotEqualTo(Byte value) {
            addCriterion("DataStatus <>", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThan(Byte value) {
            addCriterion("DataStatus >", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusGreaterThanOrEqualTo(Byte value) {
            addCriterion("DataStatus >=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThan(Byte value) {
            addCriterion("DataStatus <", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusLessThanOrEqualTo(Byte value) {
            addCriterion("DataStatus <=", value, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusIn(List<Byte> values) {
            addCriterion("DataStatus in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotIn(List<Byte> values) {
            addCriterion("DataStatus not in", values, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusBetween(Byte value1, Byte value2) {
            addCriterion("DataStatus between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andDatastatusNotBetween(Byte value1, Byte value2) {
            addCriterion("DataStatus not between", value1, value2, "datastatus");
            return (Criteria) this;
        }

        public Criteria andWhetherIsNull() {
            addCriterion("Whether is null");
            return (Criteria) this;
        }

        public Criteria andWhetherIsNotNull() {
            addCriterion("Whether is not null");
            return (Criteria) this;
        }

        public Criteria andWhetherEqualTo(Byte value) {
            addCriterion("Whether =", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherNotEqualTo(Byte value) {
            addCriterion("Whether <>", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherGreaterThan(Byte value) {
            addCriterion("Whether >", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherGreaterThanOrEqualTo(Byte value) {
            addCriterion("Whether >=", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherLessThan(Byte value) {
            addCriterion("Whether <", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherLessThanOrEqualTo(Byte value) {
            addCriterion("Whether <=", value, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherIn(List<Byte> values) {
            addCriterion("Whether in", values, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherNotIn(List<Byte> values) {
            addCriterion("Whether not in", values, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherBetween(Byte value1, Byte value2) {
            addCriterion("Whether between", value1, value2, "whether");
            return (Criteria) this;
        }

        public Criteria andWhetherNotBetween(Byte value1, Byte value2) {
            addCriterion("Whether not between", value1, value2, "whether");
            return (Criteria) this;
        }

        public Criteria andThreadtypeIsNull() {
            addCriterion("ThreadType is null");
            return (Criteria) this;
        }

        public Criteria andThreadtypeIsNotNull() {
            addCriterion("ThreadType is not null");
            return (Criteria) this;
        }

        public Criteria andThreadtypeEqualTo(Long value) {
            addCriterion("ThreadType =", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeNotEqualTo(Long value) {
            addCriterion("ThreadType <>", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeGreaterThan(Long value) {
            addCriterion("ThreadType >", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeGreaterThanOrEqualTo(Long value) {
            addCriterion("ThreadType >=", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeLessThan(Long value) {
            addCriterion("ThreadType <", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeLessThanOrEqualTo(Long value) {
            addCriterion("ThreadType <=", value, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeIn(List<Long> values) {
            addCriterion("ThreadType in", values, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeNotIn(List<Long> values) {
            addCriterion("ThreadType not in", values, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeBetween(Long value1, Long value2) {
            addCriterion("ThreadType between", value1, value2, "threadtype");
            return (Criteria) this;
        }

        public Criteria andThreadtypeNotBetween(Long value1, Long value2) {
            addCriterion("ThreadType not between", value1, value2, "threadtype");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("CreateTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("CreateTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("CreateTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("CreateTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("CreateTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CreateTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("CreateTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("CreateTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("CreateTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("CreateTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("CreateTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("CreateTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNull() {
            addCriterion("UpdateTime is null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIsNotNull() {
            addCriterion("UpdateTime is not null");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeEqualTo(Date value) {
            addCriterion("UpdateTime =", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotEqualTo(Date value) {
            addCriterion("UpdateTime <>", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThan(Date value) {
            addCriterion("UpdateTime >", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("UpdateTime >=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThan(Date value) {
            addCriterion("UpdateTime <", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeLessThanOrEqualTo(Date value) {
            addCriterion("UpdateTime <=", value, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeIn(List<Date> values) {
            addCriterion("UpdateTime in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotIn(List<Date> values) {
            addCriterion("UpdateTime not in", values, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeBetween(Date value1, Date value2) {
            addCriterion("UpdateTime between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andUpdatetimeNotBetween(Date value1, Date value2) {
            addCriterion("UpdateTime not between", value1, value2, "updatetime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeIsNull() {
            addCriterion("TransformTime is null");
            return (Criteria) this;
        }

        public Criteria andTransformtimeIsNotNull() {
            addCriterion("TransformTime is not null");
            return (Criteria) this;
        }

        public Criteria andTransformtimeEqualTo(Date value) {
            addCriterion("TransformTime =", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeNotEqualTo(Date value) {
            addCriterion("TransformTime <>", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeGreaterThan(Date value) {
            addCriterion("TransformTime >", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeGreaterThanOrEqualTo(Date value) {
            addCriterion("TransformTime >=", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeLessThan(Date value) {
            addCriterion("TransformTime <", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeLessThanOrEqualTo(Date value) {
            addCriterion("TransformTime <=", value, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeIn(List<Date> values) {
            addCriterion("TransformTime in", values, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeNotIn(List<Date> values) {
            addCriterion("TransformTime not in", values, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeBetween(Date value1, Date value2) {
            addCriterion("TransformTime between", value1, value2, "transformtime");
            return (Criteria) this;
        }

        public Criteria andTransformtimeNotBetween(Date value1, Date value2) {
            addCriterion("TransformTime not between", value1, value2, "transformtime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("Remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("Remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("Remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("Remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("Remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("Remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("Remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("Remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("Remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("Remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("Remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("Remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("Remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("Remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNull() {
            addCriterion("AccountID is null");
            return (Criteria) this;
        }

        public Criteria andAccountidIsNotNull() {
            addCriterion("AccountID is not null");
            return (Criteria) this;
        }

        public Criteria andAccountidEqualTo(Long value) {
            addCriterion("AccountID =", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotEqualTo(Long value) {
            addCriterion("AccountID <>", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThan(Long value) {
            addCriterion("AccountID >", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidGreaterThanOrEqualTo(Long value) {
            addCriterion("AccountID >=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThan(Long value) {
            addCriterion("AccountID <", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidLessThanOrEqualTo(Long value) {
            addCriterion("AccountID <=", value, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidIn(List<Long> values) {
            addCriterion("AccountID in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotIn(List<Long> values) {
            addCriterion("AccountID not in", values, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidBetween(Long value1, Long value2) {
            addCriterion("AccountID between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andAccountidNotBetween(Long value1, Long value2) {
            addCriterion("AccountID not between", value1, value2, "accountid");
            return (Criteria) this;
        }

        public Criteria andIntetionidIsNull() {
            addCriterion("IntetionID is null");
            return (Criteria) this;
        }

        public Criteria andIntetionidIsNotNull() {
            addCriterion("IntetionID is not null");
            return (Criteria) this;
        }

        public Criteria andIntetionidEqualTo(Long value) {
            addCriterion("IntetionID =", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidNotEqualTo(Long value) {
            addCriterion("IntetionID <>", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidGreaterThan(Long value) {
            addCriterion("IntetionID >", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidGreaterThanOrEqualTo(Long value) {
            addCriterion("IntetionID >=", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidLessThan(Long value) {
            addCriterion("IntetionID <", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidLessThanOrEqualTo(Long value) {
            addCriterion("IntetionID <=", value, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidIn(List<Long> values) {
            addCriterion("IntetionID in", values, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidNotIn(List<Long> values) {
            addCriterion("IntetionID not in", values, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidBetween(Long value1, Long value2) {
            addCriterion("IntetionID between", value1, value2, "intetionid");
            return (Criteria) this;
        }

        public Criteria andIntetionidNotBetween(Long value1, Long value2) {
            addCriterion("IntetionID not between", value1, value2, "intetionid");
            return (Criteria) this;
        }

        public Criteria andHouseestateIsNull() {
            addCriterion("HouseEstate is null");
            return (Criteria) this;
        }

        public Criteria andHouseestateIsNotNull() {
            addCriterion("HouseEstate is not null");
            return (Criteria) this;
        }

        public Criteria andHouseestateEqualTo(Long value) {
            addCriterion("HouseEstate =", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateNotEqualTo(Long value) {
            addCriterion("HouseEstate <>", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateGreaterThan(Long value) {
            addCriterion("HouseEstate >", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateGreaterThanOrEqualTo(Long value) {
            addCriterion("HouseEstate >=", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateLessThan(Long value) {
            addCriterion("HouseEstate <", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateLessThanOrEqualTo(Long value) {
            addCriterion("HouseEstate <=", value, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateIn(List<Long> values) {
            addCriterion("HouseEstate in", values, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateNotIn(List<Long> values) {
            addCriterion("HouseEstate not in", values, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateBetween(Long value1, Long value2) {
            addCriterion("HouseEstate between", value1, value2, "houseestate");
            return (Criteria) this;
        }

        public Criteria andHouseestateNotBetween(Long value1, Long value2) {
            addCriterion("HouseEstate not between", value1, value2, "houseestate");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNull() {
            addCriterion("Province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("Province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("Province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("Province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("Province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("Province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("Province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("Province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("Province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("Province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("Province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("Province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("Province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("Province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("City is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("City is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("City =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("City <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("City >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("City >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("City <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("City <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("City like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("City not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("City in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("City not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("City between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("City not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCountyIsNull() {
            addCriterion("County is null");
            return (Criteria) this;
        }

        public Criteria andCountyIsNotNull() {
            addCriterion("County is not null");
            return (Criteria) this;
        }

        public Criteria andCountyEqualTo(String value) {
            addCriterion("County =", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotEqualTo(String value) {
            addCriterion("County <>", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThan(String value) {
            addCriterion("County >", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyGreaterThanOrEqualTo(String value) {
            addCriterion("County >=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThan(String value) {
            addCriterion("County <", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLessThanOrEqualTo(String value) {
            addCriterion("County <=", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyLike(String value) {
            addCriterion("County like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotLike(String value) {
            addCriterion("County not like", value, "county");
            return (Criteria) this;
        }

        public Criteria andCountyIn(List<String> values) {
            addCriterion("County in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotIn(List<String> values) {
            addCriterion("County not in", values, "county");
            return (Criteria) this;
        }

        public Criteria andCountyBetween(String value1, String value2) {
            addCriterion("County between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andCountyNotBetween(String value1, String value2) {
            addCriterion("County not between", value1, value2, "county");
            return (Criteria) this;
        }

        public Criteria andAdressIsNull() {
            addCriterion("Adress is null");
            return (Criteria) this;
        }

        public Criteria andAdressIsNotNull() {
            addCriterion("Adress is not null");
            return (Criteria) this;
        }

        public Criteria andAdressEqualTo(String value) {
            addCriterion("Adress =", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressNotEqualTo(String value) {
            addCriterion("Adress <>", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressGreaterThan(String value) {
            addCriterion("Adress >", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressGreaterThanOrEqualTo(String value) {
            addCriterion("Adress >=", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressLessThan(String value) {
            addCriterion("Adress <", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressLessThanOrEqualTo(String value) {
            addCriterion("Adress <=", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressLike(String value) {
            addCriterion("Adress like", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressNotLike(String value) {
            addCriterion("Adress not like", value, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressIn(List<String> values) {
            addCriterion("Adress in", values, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressNotIn(List<String> values) {
            addCriterion("Adress not in", values, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressBetween(String value1, String value2) {
            addCriterion("Adress between", value1, value2, "adress");
            return (Criteria) this;
        }

        public Criteria andAdressNotBetween(String value1, String value2) {
            addCriterion("Adress not between", value1, value2, "adress");
            return (Criteria) this;
        }

        public Criteria andHousetypeIsNull() {
            addCriterion("HouseType is null");
            return (Criteria) this;
        }

        public Criteria andHousetypeIsNotNull() {
            addCriterion("HouseType is not null");
            return (Criteria) this;
        }

        public Criteria andHousetypeEqualTo(Byte value) {
            addCriterion("HouseType =", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeNotEqualTo(Byte value) {
            addCriterion("HouseType <>", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeGreaterThan(Byte value) {
            addCriterion("HouseType >", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeGreaterThanOrEqualTo(Byte value) {
            addCriterion("HouseType >=", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeLessThan(Byte value) {
            addCriterion("HouseType <", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeLessThanOrEqualTo(Byte value) {
            addCriterion("HouseType <=", value, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeIn(List<Byte> values) {
            addCriterion("HouseType in", values, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeNotIn(List<Byte> values) {
            addCriterion("HouseType not in", values, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeBetween(Byte value1, Byte value2) {
            addCriterion("HouseType between", value1, value2, "housetype");
            return (Criteria) this;
        }

        public Criteria andHousetypeNotBetween(Byte value1, Byte value2) {
            addCriterion("HouseType not between", value1, value2, "housetype");
            return (Criteria) this;
        }

        public Criteria andHouselayoutIsNull() {
            addCriterion("HouseLayout is null");
            return (Criteria) this;
        }

        public Criteria andHouselayoutIsNotNull() {
            addCriterion("HouseLayout is not null");
            return (Criteria) this;
        }

        public Criteria andHouselayoutEqualTo(Byte value) {
            addCriterion("HouseLayout =", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutNotEqualTo(Byte value) {
            addCriterion("HouseLayout <>", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutGreaterThan(Byte value) {
            addCriterion("HouseLayout >", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutGreaterThanOrEqualTo(Byte value) {
            addCriterion("HouseLayout >=", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutLessThan(Byte value) {
            addCriterion("HouseLayout <", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutLessThanOrEqualTo(Byte value) {
            addCriterion("HouseLayout <=", value, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutIn(List<Byte> values) {
            addCriterion("HouseLayout in", values, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutNotIn(List<Byte> values) {
            addCriterion("HouseLayout not in", values, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutBetween(Byte value1, Byte value2) {
            addCriterion("HouseLayout between", value1, value2, "houselayout");
            return (Criteria) this;
        }

        public Criteria andHouselayoutNotBetween(Byte value1, Byte value2) {
            addCriterion("HouseLayout not between", value1, value2, "houselayout");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyIsNull() {
            addCriterion("BudgetMoney is null");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyIsNotNull() {
            addCriterion("BudgetMoney is not null");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyEqualTo(Float value) {
            addCriterion("BudgetMoney =", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyNotEqualTo(Float value) {
            addCriterion("BudgetMoney <>", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyGreaterThan(Float value) {
            addCriterion("BudgetMoney >", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyGreaterThanOrEqualTo(Float value) {
            addCriterion("BudgetMoney >=", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyLessThan(Float value) {
            addCriterion("BudgetMoney <", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyLessThanOrEqualTo(Float value) {
            addCriterion("BudgetMoney <=", value, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyIn(List<Float> values) {
            addCriterion("BudgetMoney in", values, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyNotIn(List<Float> values) {
            addCriterion("BudgetMoney not in", values, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyBetween(Float value1, Float value2) {
            addCriterion("BudgetMoney between", value1, value2, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andBudgetmoneyNotBetween(Float value1, Float value2) {
            addCriterion("BudgetMoney not between", value1, value2, "budgetmoney");
            return (Criteria) this;
        }

        public Criteria andHouseareaIsNull() {
            addCriterion("HouseArea is null");
            return (Criteria) this;
        }

        public Criteria andHouseareaIsNotNull() {
            addCriterion("HouseArea is not null");
            return (Criteria) this;
        }

        public Criteria andHouseareaEqualTo(Double value) {
            addCriterion("HouseArea =", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaNotEqualTo(Double value) {
            addCriterion("HouseArea <>", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaGreaterThan(Double value) {
            addCriterion("HouseArea >", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaGreaterThanOrEqualTo(Double value) {
            addCriterion("HouseArea >=", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaLessThan(Double value) {
            addCriterion("HouseArea <", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaLessThanOrEqualTo(Double value) {
            addCriterion("HouseArea <=", value, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaIn(List<Double> values) {
            addCriterion("HouseArea in", values, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaNotIn(List<Double> values) {
            addCriterion("HouseArea not in", values, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaBetween(Double value1, Double value2) {
            addCriterion("HouseArea between", value1, value2, "housearea");
            return (Criteria) this;
        }

        public Criteria andHouseareaNotBetween(Double value1, Double value2) {
            addCriterion("HouseArea not between", value1, value2, "housearea");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNull() {
            addCriterion("CompanyID is null");
            return (Criteria) this;
        }

        public Criteria andCompanyidIsNotNull() {
            addCriterion("CompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyidEqualTo(Long value) {
            addCriterion("CompanyID =", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotEqualTo(Long value) {
            addCriterion("CompanyID <>", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThan(Long value) {
            addCriterion("CompanyID >", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidGreaterThanOrEqualTo(Long value) {
            addCriterion("CompanyID >=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThan(Long value) {
            addCriterion("CompanyID <", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidLessThanOrEqualTo(Long value) {
            addCriterion("CompanyID <=", value, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidIn(List<Long> values) {
            addCriterion("CompanyID in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotIn(List<Long> values) {
            addCriterion("CompanyID not in", values, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidBetween(Long value1, Long value2) {
            addCriterion("CompanyID between", value1, value2, "companyid");
            return (Criteria) this;
        }

        public Criteria andCompanyidNotBetween(Long value1, Long value2) {
            addCriterion("CompanyID not between", value1, value2, "companyid");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}